問題描述
如何附加 pg_dump 備份命令 PostgreSQL 的日誌輸出 (How to append log output of pg_dump backup command PostgreSQL)
我正在使用下面的命令來追加。
pg_dump ‑Fc ‑h hostname ‑W ‑‑dbname=dbanme ‑f dbname.sql ‑‑username 2>demo.log
我要像下面的示例輸出一樣登錄到 demo.log。
pg_dump: reading user‑defined tables
pg_dump: reading packages variables
pg_dump: reading user‑defined packages
pg_dump: reading user‑defined synonyms
pg_dump: reading extensions
pg_dump: reading user‑defined functions
pg_dump: reading user‑defined types
pg_dump: finding typelem dependencies for user‑defined types
pg_dump: reading procedural languages
pg_dump: reading user‑defined aggregate functions
.
.
.
....```
If we run in mysql using ‑‑verbose it will log all stuff using below command.
``` mysqldump ‑u ‑p dbname ‑‑log‑error=error.log ‑‑verbose >bkp.sql```
how we can achive in PostgreSQL?
Please help.
參考解法
方法 1:
use ‑‑verbose as stated below
./pg_dump ‑Fc ‑h hostname ‑W ‑‑dbname=dbanme ‑f dbname.sql ‑‑username postgres ‑‑verbose 2>demo.log
Disclosure: I work for EnterpriseDB (EDB)
(by Adam Mulla、Amjad Shahzad)